package com.ourteam.system.dao;

import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;

import org.apache.commons.lang.StringUtils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;


/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2018-07-31 15:13:28
  * Warning ! This file will be overwrite when regenerate !
  *
 */
public class SysModuleDAOQueryBean extends BaseQueryBean {
    public SysModuleDAOQueryBean() {
        super();
    }

    public SysModuleDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }

    public SysModuleDAOQueryBean(BaseQueryBean aQueryBean, Map tableReplaceMap) {
        super(aQueryBean, tableReplaceMap);
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria(this);
    }

    public void addIdSelectProperty() {
        addIdSelectProperty("id");
    }

    public void addIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.Id, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.Id, "id");
        }
    }

    public void addModuleCodeSelectProperty() {
        addModuleCodeSelectProperty("moduleCode");
    }

    public void addModuleCodeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.ModuleCode, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.ModuleCode, "moduleCode");
        }
    }

    public void addModuleNameSelectProperty() {
        addModuleNameSelectProperty("moduleName");
    }

    public void addModuleNameSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.ModuleName, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.ModuleName, "moduleName");
        }
    }

    public void addParentModuleIdSelectProperty() {
        addParentModuleIdSelectProperty("parentModuleId");
    }

    public void addParentModuleIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.ParentModuleId, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.ParentModuleId, "parentModuleId");
        }
    }

    public void addRemarksSelectProperty() {
        addRemarksSelectProperty("remarks");
    }

    public void addRemarksSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.Remarks, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.Remarks, "remarks");
        }
    }

    public void addStatusSelectProperty() {
        addStatusSelectProperty("status");
    }

    public void addStatusSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.Status, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.Status, "status");
        }
    }

    public void addDomainIdSelectProperty() {
        addDomainIdSelectProperty("domainId");
    }

    public void addDomainIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.DomainId, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.DomainId, "domainId");
        }
    }

    public void addModuleIconSelectProperty() {
        addModuleIconSelectProperty("moduleIcon");
    }

    public void addModuleIconSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.ModuleIcon, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.ModuleIcon, "moduleIcon");
        }
    }

    public void addSortIndexSelectProperty() {
        addSortIndexSelectProperty("sortIndex");
    }

    public void addSortIndexSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.SortIndex, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.SortIndex, "sortIndex");
        }
    }

    public void addModuleIconContentSelectProperty() {
        addModuleIconContentSelectProperty("moduleIconContent");
    }

    public void addModuleIconContentSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.ModuleIconContent, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.ModuleIconContent,
                "moduleIconContent");
        }
    }

    public void addModuleTypeSelectProperty() {
        addModuleTypeSelectProperty("moduleType");
    }

    public void addModuleTypeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.ModuleType, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.ModuleType, "moduleType");
        }
    }

    public void addDomainCodeSelectProperty() {
        addDomainCodeSelectProperty("domainCode");
    }

    public void addDomainCodeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.DomainCode, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.DomainCode, "domainCode");
        }
    }

    public void addDomainNameSelectProperty() {
        addDomainNameSelectProperty("domainName");
    }

    public void addDomainNameSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysModuleDAO.DomainName, aAlias);
        } else {
            addSelectProperty(ISysModuleDAO.DomainName, "domainName");
        }
    }

    public void addAllSelectProperties() {
        addIdSelectProperty();

        addModuleCodeSelectProperty();

        addModuleNameSelectProperty();

        addParentModuleIdSelectProperty();

        addRemarksSelectProperty();

        addStatusSelectProperty();

        addDomainIdSelectProperty();

        addModuleIconSelectProperty();

        addSortIndexSelectProperty();

        addModuleIconContentSelectProperty();

        addModuleTypeSelectProperty();

        addDomainCodeSelectProperty();

        addDomainNameSelectProperty();
    }

    public static class Criteria extends BaseWhereCriterion<SysModuleDAOQueryBean> {
        protected Criteria(SysModuleDAOQueryBean aParentObject) {
            super(aParentObject);
        }

        public Criteria andIdIsNull() {
            addCriterion(ISysModuleDAO.Id + " is null");

            return this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion(ISysModuleDAO.Id + " is not null");

            return this;
        }

        public Criteria andIdIsNotEmpty() {
            addCriterion(ISysModuleDAO.Id + " is not null AND " +
                ISysModuleDAO.Id + " <> ''");

            return this;
        }

        public Criteria andIdIsEmpty() {
            addCriterion("(" + ISysModuleDAO.Id + " is null OR " +
                ISysModuleDAO.Id + " = '')");

            return this;
        }

        public Criteria andIdEqualTo(long value) {
            return andIdEqualTo(Long.valueOf(value));
        }

        public Criteria andIdEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.Id + " = ", value, "id");

            return this;
        }

        public Criteria andIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Id);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Id + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotEqualTo(long value) {
            return andIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToOrIsNull(long value) {
            return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysModuleDAO.Id + " is null OR " + ISysModuleDAO.Id +
                " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Id);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Id + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThan(long value) {
            return andIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysModuleDAO.Id + " >", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Id);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Id + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(long value) {
            return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.Id + " >=", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Id);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Id + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThan(long value) {
            return andIdLessThan(Long.valueOf(value));
        }

        public Criteria andIdLessThan(java.lang.Long value) {
            addCriterion(ISysModuleDAO.Id + " <", value, "id");

            return this;
        }

        public Criteria andIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Id);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Id + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(long value) {
            return andIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.Id + " <=", value, "id");

            return this;
        }

        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Id);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Id + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdIn(long[] values) {
            if (values.length == 1) {
                return andIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysModuleDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysModuleDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.Id + " in", Arrays.asList(values),
                    "id");

                return this;
            }
        }

        public Criteria andIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.Id + " not in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Id + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Id + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdBetween(long value1, long value2) {
            addCriterion(ISysModuleDAO.Id + " between", value1, value2, "id");

            return this;
        }

        public Criteria andIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysModuleDAO.Id + " between", value1, value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(long value1, long value2) {
            addCriterion(ISysModuleDAO.Id + " not between", value1, value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysModuleDAO.Id + " not between", value1, value2, "id");

            return this;
        }

        public Criteria andModuleCodeIsNull() {
            addCriterion(ISysModuleDAO.ModuleCode + " is null");

            return this;
        }

        public Criteria andModuleCodeIsNotNull() {
            addCriterion(ISysModuleDAO.ModuleCode + " is not null");

            return this;
        }

        public Criteria andModuleCodeIsNotEmpty() {
            addCriterion(ISysModuleDAO.ModuleCode + " is not null AND " +
                ISysModuleDAO.ModuleCode + " <> ''");

            return this;
        }

        public Criteria andModuleCodeIsEmpty() {
            addCriterion("(" + ISysModuleDAO.ModuleCode + " is null OR " +
                ISysModuleDAO.ModuleCode + " = '')");

            return this;
        }

        public Criteria andModuleCodeEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleCode + " = ", value, "moduleCode");

            return this;
        }

        public Criteria andModuleCodeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleCode);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleCodeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleCode + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleCodeNotEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleCode + " <>", value, "moduleCode");

            return this;
        }

        public Criteria andModuleCodeNotEqualToOrIsNull(String value) {
            addCriterion(ISysModuleDAO.ModuleCode + " is null OR " +
                ISysModuleDAO.ModuleCode + " <>", value, "moduleCode");

            return this;
        }

        public Criteria andModuleCodeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleCode);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleCodeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleCode + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleCodeGreaterThan(String value) {
            addCriterion(ISysModuleDAO.ModuleCode + " >", value, "moduleCode");

            return this;
        }

        public Criteria andModuleCodeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleCode);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleCodeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleCode + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleCodeGreaterThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleCode + " >=", value, "moduleCode");

            return this;
        }

        public Criteria andModuleCodeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleCode);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleCodeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleCode + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleCodeLessThan(String value) {
            addCriterion(ISysModuleDAO.ModuleCode + " <", value, "moduleCode");

            return this;
        }

        public Criteria andModuleCodeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleCode);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleCodeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleCode + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleCodeLessThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleCode + " <=", value, "moduleCode");

            return this;
        }

        public Criteria andModuleCodeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleCode);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleCodeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleCode + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleCodeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.ModuleCode + " like", buffer.toString(),
                "moduleCode");

            return this;
        }

        public Criteria andModuleCodeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.ModuleCode + " not like",
                buffer.toString(), "moduleCode");

            return this;
        }

        public Criteria andModuleCodeIn(List<String> values) {
            if (values.size() == 1) {
                return andModuleCodeEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleCode + " in", values,
                    "moduleCode");

                return this;
            }
        }

        public Criteria andModuleCodeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andModuleCodeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleCode + " not in", values,
                    "moduleCode");

                return this;
            }
        }

        public Criteria andModuleCodeIn(String[] values) {
            if (values.length == 1) {
                return andModuleCodeEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleCode + " in",
                    Arrays.asList(values), "moduleCode");

                return this;
            }
        }

        public Criteria andModuleCodeNotIn(String[] values) {
            if (values.length == 1) {
                return andModuleCodeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleCode + " not in",
                    Arrays.asList(values), "moduleCode");

                return this;
            }
        }

        public Criteria andModuleCodeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleCode + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleCodeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleCode + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andModuleCodeBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.ModuleCode + " between", value1, value2,
                "moduleCode");

            return this;
        }

        public Criteria andModuleCodeNotBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.ModuleCode + " not between", value1,
                value2, "moduleCode");

            return this;
        }

        public Criteria andModuleNameIsNull() {
            addCriterion(ISysModuleDAO.ModuleName + " is null");

            return this;
        }

        public Criteria andModuleNameIsNotNull() {
            addCriterion(ISysModuleDAO.ModuleName + " is not null");

            return this;
        }

        public Criteria andModuleNameIsNotEmpty() {
            addCriterion(ISysModuleDAO.ModuleName + " is not null AND " +
                ISysModuleDAO.ModuleName + " <> ''");

            return this;
        }

        public Criteria andModuleNameIsEmpty() {
            addCriterion("(" + ISysModuleDAO.ModuleName + " is null OR " +
                ISysModuleDAO.ModuleName + " = '')");

            return this;
        }

        public Criteria andModuleNameEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleName + " = ", value, "moduleName");

            return this;
        }

        public Criteria andModuleNameEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleName);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleNameEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleName + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleNameNotEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleName + " <>", value, "moduleName");

            return this;
        }

        public Criteria andModuleNameNotEqualToOrIsNull(String value) {
            addCriterion(ISysModuleDAO.ModuleName + " is null OR " +
                ISysModuleDAO.ModuleName + " <>", value, "moduleName");

            return this;
        }

        public Criteria andModuleNameNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleName);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleNameNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleName + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleNameGreaterThan(String value) {
            addCriterion(ISysModuleDAO.ModuleName + " >", value, "moduleName");

            return this;
        }

        public Criteria andModuleNameGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleName);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleNameGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleName + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleNameGreaterThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleName + " >=", value, "moduleName");

            return this;
        }

        public Criteria andModuleNameGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleName);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleNameGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleName + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleNameLessThan(String value) {
            addCriterion(ISysModuleDAO.ModuleName + " <", value, "moduleName");

            return this;
        }

        public Criteria andModuleNameLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleName);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleNameLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleName + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleNameLessThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleName + " <=", value, "moduleName");

            return this;
        }

        public Criteria andModuleNameLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleName);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleNameLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleName + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleNameLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.ModuleName + " like", buffer.toString(),
                "moduleName");

            return this;
        }

        public Criteria andModuleNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.ModuleName + " not like",
                buffer.toString(), "moduleName");

            return this;
        }

        public Criteria andModuleNameIn(List<String> values) {
            if (values.size() == 1) {
                return andModuleNameEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleName + " in", values,
                    "moduleName");

                return this;
            }
        }

        public Criteria andModuleNameNotIn(List<String> values) {
            if (values.size() == 1) {
                return andModuleNameNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleName + " not in", values,
                    "moduleName");

                return this;
            }
        }

        public Criteria andModuleNameIn(String[] values) {
            if (values.length == 1) {
                return andModuleNameEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleName + " in",
                    Arrays.asList(values), "moduleName");

                return this;
            }
        }

        public Criteria andModuleNameNotIn(String[] values) {
            if (values.length == 1) {
                return andModuleNameNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleName + " not in",
                    Arrays.asList(values), "moduleName");

                return this;
            }
        }

        public Criteria andModuleNameIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleName + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleNameNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleName + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andModuleNameBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.ModuleName + " between", value1, value2,
                "moduleName");

            return this;
        }

        public Criteria andModuleNameNotBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.ModuleName + " not between", value1,
                value2, "moduleName");

            return this;
        }

        public Criteria andParentModuleIdIsNull() {
            addCriterion(ISysModuleDAO.ParentModuleId + " is null");

            return this;
        }

        public Criteria andParentModuleIdIsNotNull() {
            addCriterion(ISysModuleDAO.ParentModuleId + " is not null");

            return this;
        }

        public Criteria andParentModuleIdIsNotEmpty() {
            addCriterion(ISysModuleDAO.ParentModuleId + " is not null AND " +
                ISysModuleDAO.ParentModuleId + " <> ''");

            return this;
        }

        public Criteria andParentModuleIdIsEmpty() {
            addCriterion("(" + ISysModuleDAO.ParentModuleId + " is null OR " +
                ISysModuleDAO.ParentModuleId + " = '')");

            return this;
        }

        public Criteria andParentModuleIdEqualTo(long value) {
            return andParentModuleIdEqualTo(Long.valueOf(value));
        }

        public Criteria andParentModuleIdEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.ParentModuleId + " = ", value,
                "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ParentModuleId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andParentModuleIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ParentModuleId + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andParentModuleIdNotEqualTo(long value) {
            return andParentModuleIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andParentModuleIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.ParentModuleId + " <>", value,
                "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdNotEqualToOrIsNull(long value) {
            return andParentModuleIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andParentModuleIdNotEqualToOrIsNull(
            java.lang.Long value) {
            addCriterion(ISysModuleDAO.ParentModuleId + " is null OR " +
                ISysModuleDAO.ParentModuleId + " <>", value, "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ParentModuleId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andParentModuleIdNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ParentModuleId + " <> ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andParentModuleIdGreaterThan(long value) {
            return andParentModuleIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andParentModuleIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysModuleDAO.ParentModuleId + " >", value,
                "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ParentModuleId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andParentModuleIdGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ParentModuleId + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andParentModuleIdGreaterThanOrEqualTo(long value) {
            return andParentModuleIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andParentModuleIdGreaterThanOrEqualTo(
            java.lang.Long value) {
            addCriterion(ISysModuleDAO.ParentModuleId + " >=", value,
                "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ParentModuleId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andParentModuleIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ParentModuleId + " >= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andParentModuleIdLessThan(long value) {
            return andParentModuleIdLessThan(Long.valueOf(value));
        }

        public Criteria andParentModuleIdLessThan(java.lang.Long value) {
            addCriterion(ISysModuleDAO.ParentModuleId + " <", value,
                "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ParentModuleId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andParentModuleIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ParentModuleId + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andParentModuleIdLessThanOrEqualTo(long value) {
            return andParentModuleIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andParentModuleIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.ParentModuleId + " <=", value,
                "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ParentModuleId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andParentModuleIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ParentModuleId + " <= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andParentModuleIdIn(long[] values) {
            if (values.length == 1) {
                return andParentModuleIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysModuleDAO.ParentModuleId + " in", values,
                    "parentModuleId");

                return this;
            }
        }

        public Criteria andParentModuleIdNotIn(long[] values) {
            if (values.length == 1) {
                return andParentModuleIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysModuleDAO.ParentModuleId + " not in", values,
                    "parentModuleId");

                return this;
            }
        }

        public Criteria andParentModuleIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andParentModuleIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ParentModuleId + " in", values,
                    "parentModuleId");

                return this;
            }
        }

        public Criteria andParentModuleIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andParentModuleIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ParentModuleId + " not in", values,
                    "parentModuleId");

                return this;
            }
        }

        public Criteria andParentModuleIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andParentModuleIdEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ParentModuleId + " in",
                    Arrays.asList(values), "parentModuleId");

                return this;
            }
        }

        public Criteria andParentModuleIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andParentModuleIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ParentModuleId + " not in",
                    Arrays.asList(values), "parentModuleId");

                return this;
            }
        }

        public Criteria andParentModuleIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ParentModuleId + " in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andParentModuleIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ParentModuleId + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andParentModuleIdBetween(long value1, long value2) {
            addCriterion(ISysModuleDAO.ParentModuleId + " between", value1,
                value2, "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysModuleDAO.ParentModuleId + " between", value1,
                value2, "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdNotBetween(long value1, long value2) {
            addCriterion(ISysModuleDAO.ParentModuleId + " not between", value1,
                value2, "parentModuleId");

            return this;
        }

        public Criteria andParentModuleIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysModuleDAO.ParentModuleId + " not between", value1,
                value2, "parentModuleId");

            return this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion(ISysModuleDAO.Remarks + " is null");

            return this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion(ISysModuleDAO.Remarks + " is not null");

            return this;
        }

        public Criteria andRemarksIsNotEmpty() {
            addCriterion(ISysModuleDAO.Remarks + " is not null AND " +
                ISysModuleDAO.Remarks + " <> ''");

            return this;
        }

        public Criteria andRemarksIsEmpty() {
            addCriterion("(" + ISysModuleDAO.Remarks + " is null OR " +
                ISysModuleDAO.Remarks + " = '')");

            return this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion(ISysModuleDAO.Remarks + " = ", value, "remarks");

            return this;
        }

        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Remarks);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Remarks + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion(ISysModuleDAO.Remarks + " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToOrIsNull(String value) {
            addCriterion(ISysModuleDAO.Remarks + " is null OR " +
                ISysModuleDAO.Remarks + " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Remarks);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Remarks + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion(ISysModuleDAO.Remarks + " >", value, "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Remarks);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Remarks + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.Remarks + " >=", value, "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Remarks);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Remarks + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion(ISysModuleDAO.Remarks + " <", value, "remarks");

            return this;
        }

        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Remarks);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Remarks + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.Remarks + " <=", value, "remarks");

            return this;
        }

        public Criteria andRemarksLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Remarks);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Remarks + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.Remarks + " like", buffer.toString(),
                "remarks");

            return this;
        }

        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.Remarks + " not like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.Remarks + " in", values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.Remarks + " not in", values,
                    "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(String[] values) {
            if (values.length == 1) {
                return andRemarksEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.Remarks + " in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(String[] values) {
            if (values.length == 1) {
                return andRemarksNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.Remarks + " not in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Remarks + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Remarks + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.Remarks + " between", value1, value2,
                "remarks");

            return this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.Remarks + " not between", value1,
                value2, "remarks");

            return this;
        }

        public Criteria andStatusIsNull() {
            addCriterion(ISysModuleDAO.Status + " is null");

            return this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion(ISysModuleDAO.Status + " is not null");

            return this;
        }

        public Criteria andStatusIsNotEmpty() {
            addCriterion(ISysModuleDAO.Status + " is not null AND " +
                ISysModuleDAO.Status + " <> ''");

            return this;
        }

        public Criteria andStatusIsEmpty() {
            addCriterion("(" + ISysModuleDAO.Status + " is null OR " +
                ISysModuleDAO.Status + " = '')");

            return this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion(ISysModuleDAO.Status + " = ", value, "status");

            return this;
        }

        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Status);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Status + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion(ISysModuleDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToOrIsNull(String value) {
            addCriterion(ISysModuleDAO.Status + " is null OR " +
                ISysModuleDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Status);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Status + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion(ISysModuleDAO.Status + " >", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Status);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Status + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.Status + " >=", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Status);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Status + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion(ISysModuleDAO.Status + " <", value, "status");

            return this;
        }

        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Status);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Status + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.Status + " <=", value, "status");

            return this;
        }

        public Criteria andStatusLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.Status);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Status + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.Status + " like", buffer.toString(),
                "status");

            return this;
        }

        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.Status + " not like", buffer.toString(),
                "status");

            return this;
        }

        public Criteria andStatusIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.Status + " in", values, "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.Status + " not in", values, "status");

                return this;
            }
        }

        public Criteria andStatusIn(String[] values) {
            if (values.length == 1) {
                return andStatusEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.Status + " in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(String[] values) {
            if (values.length == 1) {
                return andStatusNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.Status + " not in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Status + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.Status + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.Status + " between", value1, value2,
                "status");

            return this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.Status + " not between", value1, value2,
                "status");

            return this;
        }

        public Criteria andDomainIdIsNull() {
            addCriterion(ISysModuleDAO.DomainId + " is null");

            return this;
        }

        public Criteria andDomainIdIsNotNull() {
            addCriterion(ISysModuleDAO.DomainId + " is not null");

            return this;
        }

        public Criteria andDomainIdIsNotEmpty() {
            addCriterion(ISysModuleDAO.DomainId + " is not null AND " +
                ISysModuleDAO.DomainId + " <> ''");

            return this;
        }

        public Criteria andDomainIdIsEmpty() {
            addCriterion("(" + ISysModuleDAO.DomainId + " is null OR " +
                ISysModuleDAO.DomainId + " = '')");

            return this;
        }

        public Criteria andDomainIdEqualTo(long value) {
            return andDomainIdEqualTo(Long.valueOf(value));
        }

        public Criteria andDomainIdEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.DomainId + " = ", value, "domainId");

            return this;
        }

        public Criteria andDomainIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainId + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdNotEqualTo(long value) {
            return andDomainIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andDomainIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.DomainId + " <>", value, "domainId");

            return this;
        }

        public Criteria andDomainIdNotEqualToOrIsNull(long value) {
            return andDomainIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andDomainIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysModuleDAO.DomainId + " is null OR " +
                ISysModuleDAO.DomainId + " <>", value, "domainId");

            return this;
        }

        public Criteria andDomainIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainId + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdGreaterThan(long value) {
            return andDomainIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andDomainIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysModuleDAO.DomainId + " >", value, "domainId");

            return this;
        }

        public Criteria andDomainIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainId + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdGreaterThanOrEqualTo(long value) {
            return andDomainIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andDomainIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.DomainId + " >=", value, "domainId");

            return this;
        }

        public Criteria andDomainIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainId + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdLessThan(long value) {
            return andDomainIdLessThan(Long.valueOf(value));
        }

        public Criteria andDomainIdLessThan(java.lang.Long value) {
            addCriterion(ISysModuleDAO.DomainId + " <", value, "domainId");

            return this;
        }

        public Criteria andDomainIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainId + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdLessThanOrEqualTo(long value) {
            return andDomainIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andDomainIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysModuleDAO.DomainId + " <=", value, "domainId");

            return this;
        }

        public Criteria andDomainIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainId + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdIn(long[] values) {
            if (values.length == 1) {
                return andDomainIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysModuleDAO.DomainId + " in", values, "domainId");

                return this;
            }
        }

        public Criteria andDomainIdNotIn(long[] values) {
            if (values.length == 1) {
                return andDomainIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysModuleDAO.DomainId + " not in", values,
                    "domainId");

                return this;
            }
        }

        public Criteria andDomainIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andDomainIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.DomainId + " in", values, "domainId");

                return this;
            }
        }

        public Criteria andDomainIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andDomainIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.DomainId + " not in", values,
                    "domainId");

                return this;
            }
        }

        public Criteria andDomainIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andDomainIdEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.DomainId + " in",
                    Arrays.asList(values), "domainId");

                return this;
            }
        }

        public Criteria andDomainIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andDomainIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.DomainId + " not in",
                    Arrays.asList(values), "domainId");

                return this;
            }
        }

        public Criteria andDomainIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainId + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainId + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdBetween(long value1, long value2) {
            addCriterion(ISysModuleDAO.DomainId + " between", value1, value2,
                "domainId");

            return this;
        }

        public Criteria andDomainIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysModuleDAO.DomainId + " between", value1, value2,
                "domainId");

            return this;
        }

        public Criteria andDomainIdNotBetween(long value1, long value2) {
            addCriterion(ISysModuleDAO.DomainId + " not between", value1,
                value2, "domainId");

            return this;
        }

        public Criteria andDomainIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysModuleDAO.DomainId + " not between", value1,
                value2, "domainId");

            return this;
        }

        public Criteria andModuleIconIsNull() {
            addCriterion(ISysModuleDAO.ModuleIcon + " is null");

            return this;
        }

        public Criteria andModuleIconIsNotNull() {
            addCriterion(ISysModuleDAO.ModuleIcon + " is not null");

            return this;
        }

        public Criteria andModuleIconIsNotEmpty() {
            addCriterion(ISysModuleDAO.ModuleIcon + " is not null AND " +
                ISysModuleDAO.ModuleIcon + " <> ''");

            return this;
        }

        public Criteria andModuleIconIsEmpty() {
            addCriterion("(" + ISysModuleDAO.ModuleIcon + " is null OR " +
                ISysModuleDAO.ModuleIcon + " = '')");

            return this;
        }

        public Criteria andModuleIconEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleIcon + " = ", value, "moduleIcon");

            return this;
        }

        public Criteria andModuleIconEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIcon);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIcon + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconNotEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleIcon + " <>", value, "moduleIcon");

            return this;
        }

        public Criteria andModuleIconNotEqualToOrIsNull(String value) {
            addCriterion(ISysModuleDAO.ModuleIcon + " is null OR " +
                ISysModuleDAO.ModuleIcon + " <>", value, "moduleIcon");

            return this;
        }

        public Criteria andModuleIconNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIcon);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIcon + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconGreaterThan(String value) {
            addCriterion(ISysModuleDAO.ModuleIcon + " >", value, "moduleIcon");

            return this;
        }

        public Criteria andModuleIconGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIcon);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIcon + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconGreaterThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleIcon + " >=", value, "moduleIcon");

            return this;
        }

        public Criteria andModuleIconGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIcon);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIcon + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconLessThan(String value) {
            addCriterion(ISysModuleDAO.ModuleIcon + " <", value, "moduleIcon");

            return this;
        }

        public Criteria andModuleIconLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIcon);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIcon + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconLessThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleIcon + " <=", value, "moduleIcon");

            return this;
        }

        public Criteria andModuleIconLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIcon);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIcon + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.ModuleIcon + " like", buffer.toString(),
                "moduleIcon");

            return this;
        }

        public Criteria andModuleIconNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.ModuleIcon + " not like",
                buffer.toString(), "moduleIcon");

            return this;
        }

        public Criteria andModuleIconIn(List<String> values) {
            if (values.size() == 1) {
                return andModuleIconEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleIcon + " in", values,
                    "moduleIcon");

                return this;
            }
        }

        public Criteria andModuleIconNotIn(List<String> values) {
            if (values.size() == 1) {
                return andModuleIconNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleIcon + " not in", values,
                    "moduleIcon");

                return this;
            }
        }

        public Criteria andModuleIconIn(String[] values) {
            if (values.length == 1) {
                return andModuleIconEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleIcon + " in",
                    Arrays.asList(values), "moduleIcon");

                return this;
            }
        }

        public Criteria andModuleIconNotIn(String[] values) {
            if (values.length == 1) {
                return andModuleIconNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleIcon + " not in",
                    Arrays.asList(values), "moduleIcon");

                return this;
            }
        }

        public Criteria andModuleIconIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIcon + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIcon + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andModuleIconBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.ModuleIcon + " between", value1, value2,
                "moduleIcon");

            return this;
        }

        public Criteria andModuleIconNotBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.ModuleIcon + " not between", value1,
                value2, "moduleIcon");

            return this;
        }

        public Criteria andSortIndexIsNull() {
            addCriterion(ISysModuleDAO.SortIndex + " is null");

            return this;
        }

        public Criteria andSortIndexIsNotNull() {
            addCriterion(ISysModuleDAO.SortIndex + " is not null");

            return this;
        }

        public Criteria andSortIndexIsNotEmpty() {
            addCriterion(ISysModuleDAO.SortIndex + " is not null AND " +
                ISysModuleDAO.SortIndex + " <> ''");

            return this;
        }

        public Criteria andSortIndexIsEmpty() {
            addCriterion("(" + ISysModuleDAO.SortIndex + " is null OR " +
                ISysModuleDAO.SortIndex + " = '')");

            return this;
        }

        public Criteria andSortIndexEqualTo(int value) {
            return andSortIndexEqualTo(Integer.valueOf(value));
        }

        public Criteria andSortIndexEqualTo(java.lang.Integer value) {
            addCriterion(ISysModuleDAO.SortIndex + " = ", value, "sortIndex");

            return this;
        }

        public Criteria andSortIndexEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.SortIndex);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSortIndexEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.SortIndex + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andSortIndexNotEqualTo(int value) {
            return andSortIndexNotEqualTo(Integer.valueOf(value));
        }

        public Criteria andSortIndexNotEqualTo(java.lang.Integer value) {
            addCriterion(ISysModuleDAO.SortIndex + " <>", value, "sortIndex");

            return this;
        }

        public Criteria andSortIndexNotEqualToOrIsNull(int value) {
            return andSortIndexNotEqualToOrIsNull(Integer.valueOf(value));
        }

        public Criteria andSortIndexNotEqualToOrIsNull(java.lang.Integer value) {
            addCriterion(ISysModuleDAO.SortIndex + " is null OR " +
                ISysModuleDAO.SortIndex + " <>", value, "sortIndex");

            return this;
        }

        public Criteria andSortIndexNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.SortIndex);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSortIndexNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.SortIndex + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andSortIndexGreaterThan(int value) {
            return andSortIndexGreaterThan(Integer.valueOf(value));
        }

        public Criteria andSortIndexGreaterThan(java.lang.Integer value) {
            addCriterion(ISysModuleDAO.SortIndex + " >", value, "sortIndex");

            return this;
        }

        public Criteria andSortIndexGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.SortIndex);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSortIndexGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.SortIndex + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andSortIndexGreaterThanOrEqualTo(int value) {
            return andSortIndexGreaterThanOrEqualTo(Integer.valueOf(value));
        }

        public Criteria andSortIndexGreaterThanOrEqualTo(
            java.lang.Integer value) {
            addCriterion(ISysModuleDAO.SortIndex + " >=", value, "sortIndex");

            return this;
        }

        public Criteria andSortIndexGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.SortIndex);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSortIndexGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.SortIndex + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andSortIndexLessThan(int value) {
            return andSortIndexLessThan(Integer.valueOf(value));
        }

        public Criteria andSortIndexLessThan(java.lang.Integer value) {
            addCriterion(ISysModuleDAO.SortIndex + " <", value, "sortIndex");

            return this;
        }

        public Criteria andSortIndexLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.SortIndex);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSortIndexLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.SortIndex + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andSortIndexLessThanOrEqualTo(int value) {
            return andSortIndexLessThanOrEqualTo(Integer.valueOf(value));
        }

        public Criteria andSortIndexLessThanOrEqualTo(java.lang.Integer value) {
            addCriterion(ISysModuleDAO.SortIndex + " <=", value, "sortIndex");

            return this;
        }

        public Criteria andSortIndexLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.SortIndex);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSortIndexLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.SortIndex + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andSortIndexIn(int[] values) {
            if (values.length == 1) {
                return andSortIndexEqualTo((java.lang.Integer) values[0]);
            } else {
                addCriterion(ISysModuleDAO.SortIndex + " in", values,
                    "sortIndex");

                return this;
            }
        }

        public Criteria andSortIndexNotIn(int[] values) {
            if (values.length == 1) {
                return andSortIndexNotEqualTo((java.lang.Integer) values[0]);
            } else {
                addCriterion(ISysModuleDAO.SortIndex + " not in", values,
                    "sortIndex");

                return this;
            }
        }

        public Criteria andSortIndexIn(List<java.lang.Integer> values) {
            if (values.size() == 1) {
                return andSortIndexEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.SortIndex + " in", values,
                    "sortIndex");

                return this;
            }
        }

        public Criteria andSortIndexNotIn(List<java.lang.Integer> values) {
            if (values.size() == 1) {
                return andSortIndexNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.SortIndex + " not in", values,
                    "sortIndex");

                return this;
            }
        }

        public Criteria andSortIndexIn(java.lang.Integer[] values) {
            if (values.length == 1) {
                return andSortIndexEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.SortIndex + " in",
                    Arrays.asList(values), "sortIndex");

                return this;
            }
        }

        public Criteria andSortIndexNotIn(java.lang.Integer[] values) {
            if (values.length == 1) {
                return andSortIndexNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.SortIndex + " not in",
                    Arrays.asList(values), "sortIndex");

                return this;
            }
        }

        public Criteria andSortIndexIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.SortIndex + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSortIndexNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.SortIndex + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSortIndexBetween(int value1, int value2) {
            addCriterion(ISysModuleDAO.SortIndex + " between", value1, value2,
                "sortIndex");

            return this;
        }

        public Criteria andSortIndexBetween(java.lang.Integer value1,
            java.lang.Integer value2) {
            addCriterion(ISysModuleDAO.SortIndex + " between", value1, value2,
                "sortIndex");

            return this;
        }

        public Criteria andSortIndexNotBetween(int value1, int value2) {
            addCriterion(ISysModuleDAO.SortIndex + " not between", value1,
                value2, "sortIndex");

            return this;
        }

        public Criteria andSortIndexNotBetween(java.lang.Integer value1,
            java.lang.Integer value2) {
            addCriterion(ISysModuleDAO.SortIndex + " not between", value1,
                value2, "sortIndex");

            return this;
        }

        public Criteria andModuleIconContentIsNull() {
            addCriterion(ISysModuleDAO.ModuleIconContent + " is null");

            return this;
        }

        public Criteria andModuleIconContentIsNotNull() {
            addCriterion(ISysModuleDAO.ModuleIconContent + " is not null");

            return this;
        }

        public Criteria andModuleIconContentIsNotEmpty() {
            addCriterion(ISysModuleDAO.ModuleIconContent + " is not null AND " +
                ISysModuleDAO.ModuleIconContent + " <> ''");

            return this;
        }

        public Criteria andModuleIconContentIsEmpty() {
            addCriterion("(" + ISysModuleDAO.ModuleIconContent +
                " is null OR " + ISysModuleDAO.ModuleIconContent + " = '')");

            return this;
        }

        public Criteria andModuleIconContentEqualTo(byte[] value) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " = ", value,
                "moduleIconContent");

            return this;
        }

        public Criteria andModuleIconContentEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIconContent);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconContentEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " = ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andModuleIconContentNotEqualTo(byte[] value) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " <>", value,
                "moduleIconContent");

            return this;
        }

        public Criteria andModuleIconContentNotEqualToOrIsNull(byte[] value) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " is null OR " +
                ISysModuleDAO.ModuleIconContent + " <>", value,
                "moduleIconContent");

            return this;
        }

        public Criteria andModuleIconContentNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIconContent);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconContentNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconContentGreaterThan(byte[] value) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " >", value,
                "moduleIconContent");

            return this;
        }

        public Criteria andModuleIconContentGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIconContent);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconContentGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " > ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andModuleIconContentGreaterThanOrEqualTo(byte[] value) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " >=", value,
                "moduleIconContent");

            return this;
        }

        public Criteria andModuleIconContentGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIconContent);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconContentGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconContentLessThan(byte[] value) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " <", value,
                "moduleIconContent");

            return this;
        }

        public Criteria andModuleIconContentLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIconContent);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconContentLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " < ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andModuleIconContentLessThanOrEqualTo(byte[] value) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " <=", value,
                "moduleIconContent");

            return this;
        }

        public Criteria andModuleIconContentLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleIconContent);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleIconContentLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconContentIn(List<byte[]> values) {
            if (values.size() == 1) {
                return andModuleIconContentEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleIconContent + " in", values,
                    "moduleIconContent");

                return this;
            }
        }

        public Criteria andModuleIconContentNotIn(List<byte[]> values) {
            if (values.size() == 1) {
                return andModuleIconContentNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleIconContent + " not in",
                    values, "moduleIconContent");

                return this;
            }
        }

        public Criteria andModuleIconContentIn(byte[][] values) {
            if (values.length == 1) {
                return andModuleIconContentEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleIconContent + " in",
                    Arrays.asList(values), "moduleIconContent");

                return this;
            }
        }

        public Criteria andModuleIconContentNotIn(byte[][] values) {
            if (values.length == 1) {
                return andModuleIconContentNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleIconContent + " not in",
                    Arrays.asList(values), "moduleIconContent");

                return this;
            }
        }

        public Criteria andModuleIconContentIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconContentNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andModuleIconContentBetween(byte[] value1, byte[] value2) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " between", value1,
                value2, "moduleIconContent");

            return this;
        }

        public Criteria andModuleIconContentNotBetween(byte[] value1,
            byte[] value2) {
            addCriterion(ISysModuleDAO.ModuleIconContent + " not between",
                value1, value2, "moduleIconContent");

            return this;
        }

        public Criteria andModuleTypeIsNull() {
            addCriterion(ISysModuleDAO.ModuleType + " is null");

            return this;
        }

        public Criteria andModuleTypeIsNotNull() {
            addCriterion(ISysModuleDAO.ModuleType + " is not null");

            return this;
        }

        public Criteria andModuleTypeIsNotEmpty() {
            addCriterion(ISysModuleDAO.ModuleType + " is not null AND " +
                ISysModuleDAO.ModuleType + " <> ''");

            return this;
        }

        public Criteria andModuleTypeIsEmpty() {
            addCriterion("(" + ISysModuleDAO.ModuleType + " is null OR " +
                ISysModuleDAO.ModuleType + " = '')");

            return this;
        }

        public Criteria andModuleTypeEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleType + " = ", value, "moduleType");

            return this;
        }

        public Criteria andModuleTypeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleType);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleTypeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleType + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleTypeNotEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleType + " <>", value, "moduleType");

            return this;
        }

        public Criteria andModuleTypeNotEqualToOrIsNull(String value) {
            addCriterion(ISysModuleDAO.ModuleType + " is null OR " +
                ISysModuleDAO.ModuleType + " <>", value, "moduleType");

            return this;
        }

        public Criteria andModuleTypeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleType);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleTypeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleType + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleTypeGreaterThan(String value) {
            addCriterion(ISysModuleDAO.ModuleType + " >", value, "moduleType");

            return this;
        }

        public Criteria andModuleTypeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleType);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleTypeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleType + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleTypeGreaterThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleType + " >=", value, "moduleType");

            return this;
        }

        public Criteria andModuleTypeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleType);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleTypeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleType + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleTypeLessThan(String value) {
            addCriterion(ISysModuleDAO.ModuleType + " <", value, "moduleType");

            return this;
        }

        public Criteria andModuleTypeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleType);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleTypeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleType + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleTypeLessThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.ModuleType + " <=", value, "moduleType");

            return this;
        }

        public Criteria andModuleTypeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.ModuleType);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModuleTypeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleType + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleTypeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.ModuleType + " like", buffer.toString(),
                "moduleType");

            return this;
        }

        public Criteria andModuleTypeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.ModuleType + " not like",
                buffer.toString(), "moduleType");

            return this;
        }

        public Criteria andModuleTypeIn(List<String> values) {
            if (values.size() == 1) {
                return andModuleTypeEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleType + " in", values,
                    "moduleType");

                return this;
            }
        }

        public Criteria andModuleTypeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andModuleTypeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.ModuleType + " not in", values,
                    "moduleType");

                return this;
            }
        }

        public Criteria andModuleTypeIn(String[] values) {
            if (values.length == 1) {
                return andModuleTypeEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleType + " in",
                    Arrays.asList(values), "moduleType");

                return this;
            }
        }

        public Criteria andModuleTypeNotIn(String[] values) {
            if (values.length == 1) {
                return andModuleTypeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.ModuleType + " not in",
                    Arrays.asList(values), "moduleType");

                return this;
            }
        }

        public Criteria andModuleTypeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleType + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andModuleTypeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.ModuleType + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andModuleTypeBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.ModuleType + " between", value1, value2,
                "moduleType");

            return this;
        }

        public Criteria andModuleTypeNotBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.ModuleType + " not between", value1,
                value2, "moduleType");

            return this;
        }

        public Criteria andDomainCodeIsNull() {
            addCriterion(ISysModuleDAO.DomainCode + " is null");

            return this;
        }

        public Criteria andDomainCodeIsNotNull() {
            addCriterion(ISysModuleDAO.DomainCode + " is not null");

            return this;
        }

        public Criteria andDomainCodeIsNotEmpty() {
            addCriterion(ISysModuleDAO.DomainCode + " is not null AND " +
                ISysModuleDAO.DomainCode + " <> ''");

            return this;
        }

        public Criteria andDomainCodeIsEmpty() {
            addCriterion("(" + ISysModuleDAO.DomainCode + " is null OR " +
                ISysModuleDAO.DomainCode + " = '')");

            return this;
        }

        public Criteria andDomainCodeEqualTo(String value) {
            addCriterion(ISysModuleDAO.DomainCode + " = ", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainCode);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainCode + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeNotEqualTo(String value) {
            addCriterion(ISysModuleDAO.DomainCode + " <>", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeNotEqualToOrIsNull(String value) {
            addCriterion(ISysModuleDAO.DomainCode + " is null OR " +
                ISysModuleDAO.DomainCode + " <>", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainCode);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainCode + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeGreaterThan(String value) {
            addCriterion(ISysModuleDAO.DomainCode + " >", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainCode);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainCode + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeGreaterThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.DomainCode + " >=", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainCode);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainCode + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeLessThan(String value) {
            addCriterion(ISysModuleDAO.DomainCode + " <", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainCode);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainCode + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeLessThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.DomainCode + " <=", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainCode);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainCode + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.DomainCode + " like", buffer.toString(),
                "domainCode");

            return this;
        }

        public Criteria andDomainCodeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.DomainCode + " not like",
                buffer.toString(), "domainCode");

            return this;
        }

        public Criteria andDomainCodeIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainCodeEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.DomainCode + " in", values,
                    "domainCode");

                return this;
            }
        }

        public Criteria andDomainCodeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainCodeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.DomainCode + " not in", values,
                    "domainCode");

                return this;
            }
        }

        public Criteria andDomainCodeIn(String[] values) {
            if (values.length == 1) {
                return andDomainCodeEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.DomainCode + " in",
                    Arrays.asList(values), "domainCode");

                return this;
            }
        }

        public Criteria andDomainCodeNotIn(String[] values) {
            if (values.length == 1) {
                return andDomainCodeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.DomainCode + " not in",
                    Arrays.asList(values), "domainCode");

                return this;
            }
        }

        public Criteria andDomainCodeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainCode + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainCode + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andDomainCodeBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.DomainCode + " between", value1, value2,
                "domainCode");

            return this;
        }

        public Criteria andDomainCodeNotBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.DomainCode + " not between", value1,
                value2, "domainCode");

            return this;
        }

        public Criteria andDomainNameIsNull() {
            addCriterion(ISysModuleDAO.DomainName + " is null");

            return this;
        }

        public Criteria andDomainNameIsNotNull() {
            addCriterion(ISysModuleDAO.DomainName + " is not null");

            return this;
        }

        public Criteria andDomainNameIsNotEmpty() {
            addCriterion(ISysModuleDAO.DomainName + " is not null AND " +
                ISysModuleDAO.DomainName + " <> ''");

            return this;
        }

        public Criteria andDomainNameIsEmpty() {
            addCriterion("(" + ISysModuleDAO.DomainName + " is null OR " +
                ISysModuleDAO.DomainName + " = '')");

            return this;
        }

        public Criteria andDomainNameEqualTo(String value) {
            addCriterion(ISysModuleDAO.DomainName + " = ", value, "domainName");

            return this;
        }

        public Criteria andDomainNameEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainName);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainName + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameNotEqualTo(String value) {
            addCriterion(ISysModuleDAO.DomainName + " <>", value, "domainName");

            return this;
        }

        public Criteria andDomainNameNotEqualToOrIsNull(String value) {
            addCriterion(ISysModuleDAO.DomainName + " is null OR " +
                ISysModuleDAO.DomainName + " <>", value, "domainName");

            return this;
        }

        public Criteria andDomainNameNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainName);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainName + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameGreaterThan(String value) {
            addCriterion(ISysModuleDAO.DomainName + " >", value, "domainName");

            return this;
        }

        public Criteria andDomainNameGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainName);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainName + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameGreaterThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.DomainName + " >=", value, "domainName");

            return this;
        }

        public Criteria andDomainNameGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainName);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainName + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameLessThan(String value) {
            addCriterion(ISysModuleDAO.DomainName + " <", value, "domainName");

            return this;
        }

        public Criteria andDomainNameLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainName);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainName + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameLessThanOrEqualTo(String value) {
            addCriterion(ISysModuleDAO.DomainName + " <=", value, "domainName");

            return this;
        }

        public Criteria andDomainNameLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysModuleDAO.DomainName);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainName + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.DomainName + " like", buffer.toString(),
                "domainName");

            return this;
        }

        public Criteria andDomainNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysModuleDAO.DomainName + " not like",
                buffer.toString(), "domainName");

            return this;
        }

        public Criteria andDomainNameIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainNameEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.DomainName + " in", values,
                    "domainName");

                return this;
            }
        }

        public Criteria andDomainNameNotIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainNameNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysModuleDAO.DomainName + " not in", values,
                    "domainName");

                return this;
            }
        }

        public Criteria andDomainNameIn(String[] values) {
            if (values.length == 1) {
                return andDomainNameEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.DomainName + " in",
                    Arrays.asList(values), "domainName");

                return this;
            }
        }

        public Criteria andDomainNameNotIn(String[] values) {
            if (values.length == 1) {
                return andDomainNameNotEqualTo(values[0]);
            } else {
                addCriterion(ISysModuleDAO.DomainName + " not in",
                    Arrays.asList(values), "domainName");

                return this;
            }
        }

        public Criteria andDomainNameIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainName + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysModuleDAO.DomainName + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andDomainNameBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.DomainName + " between", value1, value2,
                "domainName");

            return this;
        }

        public Criteria andDomainNameNotBetween(String value1, String value2) {
            addCriterion(ISysModuleDAO.DomainName + " not between", value1,
                value2, "domainName");

            return this;
        }
    }
}
